CRM 2011 security access privileges check

Hi there,

if you want to know the user’s privilege access check with in CRM interface and behind the screens can be seen by running below query in SQL

SELECT Privilege.*, RolePrivileges.*, SystemUserRoles.*
FROM Privilege
INNER JOIN RolePrivileges ON Privilege.PrivilegeId = RolePrivileges.PrivilegeId
INNER JOIN SystemUserRoles ON SystemUserRoles.RoleId = RolePrivileges.RoleId AND SystemUserRoles.SystemUserId = ‘6CC471DA-FEEB-E311-880C-00237DEC9650’

Thanks,
Sama.